package com.ksd.modules.fileRecord.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ksd.modules.fileRecord.entity.SysFileRecord;
import org.apache.ibatis.annotations.Select;

import java.util.List;
import java.util.Map;

/**
 * <p>
 * 文件上传记录表 Mapper 接口
 * </p>
 *
 * @author Auto Generator
 * @since 2023-09-17
 */
public interface SysFileRecordMapper extends BaseMapper<SysFileRecord> {
    @Select("select type,count(*) as total from sys_file_record GROUP BY type")
    List<Map<String,Object>> statistics();
}
